select * from default.swiggy

select Price from default.swiggy   
-- show the price

select avg(Price) as Price from default.swiggy

-- show average price

 select avg(AvgRatings) as AvgRatings from default.swiggy

 -- show average rating

select avg(price) as Price, avg(avgratings) as Average_Ratings from default.swiggy

-- show average price and rating in one

select city, count(city) as Counts from default.swiggy
group by city 
order by Counts desc

select City, round(avg(AvgRatings),2) as Average_Rating from default.swiggy
group by City
order by Average_Rating desc

-- Top cities with everage rating

select area , round(avg(avgratings)) as Average_Rating from default.swiggy
group by Area
order by Average_Rating desc

-- finding the average rating for areas

-- Find the total number of restaurants in the dataset.

select count(distinct(restaurant)) as Total_Numeber_of_Restaurants
from default.swiggy

-- List the names of all the restaurants in the 'Koramangala' area.

select restaurant from default.swiggy
where Area = "Koramangala"

-- Determine the restaurant with the highest average rating.

select restaurant, round(avg(avgratings)) as Average_Ratings from default.swiggy
group by Restaurant
order by Average_Ratings desc

-- Find out the average delivery time across all restaurants.

select Restaurant , round(avg(DeliveryTime)) as Average_DeliveryTime
from default.swiggy
group by Restaurant
order by Average_DeliveryTime desc

-- List the restaurants that offer 'Chinese' as a part of their food type

select restaurant from default.swiggy
where FoodType = 'Chinese'

-- Find out the restaurants with more than 200 total ratings.

select restaurant  from default.swiggy
where TotalRatings > 200

-- List the restaurants that have a delivery time less than 55 minutes and an average rating above 4

select restaurant from default.swiggy
where deliverytime < 55
and AvgRatings > 4

-- Find out the top 5 restaurants with the highest total ratings.

select restaurant, sum(TotalRatings) as TotalRatings from default.swiggy
group by restaurant
order by TotalRatings desc
limit 5

-- Determine the areas with more than 10 restaurants

SELECT Area, COUNT(*) as NumberOfRestaurants
FROM default.swiggy
GROUP BY Area
HAVING COUNT(*) > 10;